{% extends "base.html" %}
{% block content %}
{% ifequal is_con 0 %}
<script type="text/javascript" src="/static/js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="/static/js/jquery-ui-1.8.16.custom.min.js"></script>
<link href="/static/css/jquery-ui-1.8.16.custom.css" rel="stylesheet" type="text/css" />
<div class="form-div" style="margin:10px;">
  <form action='' method='get' name="searchForm">
	<table>
		<tr>
			<td style="border:0px;padding:3px;">
				<img src="/static/images/icon_search.gif" width="26" height="22" border="0" alt="SEARCH">
			</td>
			<td style="border:0px;padding:3px;">
				Date Start:<input type='text' name='starttime' id='start'>
				Date End:<input type='text' name='endtime' id='end'>
				Program:<select name="p_id" id="p_id" style="color:#CC33FF" onchange='$("input#search").click()'>
							<option value="0" selected="selected">All</option>
							{% for p in project_list %}
								<option value="{{p.id}}" {% ifequal p.id p_id %} selected="selected" {% endifequal %}>{{p.name}}</option>
							{% endfor %}
						</select>
			</td>
			<td style="border:0px;padding:3px;">
				<input type='button' id="search" value='Search'/>
			</td>
		</tr>
		<tr>
			<td style="border:0px;padding:3px;"></td>
			<td colspan='10' style="border:0px;padding:3px;">
				<div class="selectdate" days='7'>Weekly</div>
				<div class="selectdate" days='14'>Bi-weekly</div>
				<div class="selectdate" days='30'>Monthly</div>
				<div class="selectdate" days='90'>Season</div>
				<div class="selectdate" days='180'>Half-yearly</div>
				<div class="selectdate" days='365'>Yearly</div>
			</td>
		</tr>
	</table>
  </form>
  <form action="/report_export/" method='post' id='post_report'>
	<input type='hidden' name='d' value=''/>
	<input type='hidden' name='t' value=''/>
  </form>
</div>
<script type="text/javascript" src="/static/js/create_report_export.js"></script>
<script>
$(document).ready(
	function(){
    	$('#start').datepicker({"dateFormat": "yy-mm-dd",changeMonth:true,changeYear:true})
		$('#end').datepicker({"dateFormat": "yy-mm-dd",changeMonth:true,changeYear:true})
		var agodays = new Date(Date.parse(new Date().toString()) - 86400000*6);
		var year = agodays.getUTCFullYear()
		var month = (agodays.getUTCMonth()+1)>=10?(agodays.getUTCMonth()+1):'0'+(agodays.getUTCMonth()+1)
		var day = agodays.getUTCDate()>=10?agodays.getUTCDate():'0'+agodays.getUTCDate()
		var date = year+'-'+month+'-'+day
		$('#start').val(date)
		
		$('div.selectdate').click(function(){
			$('div.selectdate').removeClass('active_title')
			$('div.selectdate').css('background','')
			$(this).css('background','#defdef')
			$(this).addClass('active_title')
		})
	}
)

$("input#search").bind({
	click:function(){
		var t = this
		if(t.style.cursor == 'wait'){
			return false;
		}
		t.style.cursor = 'wait'
		var data = $('form[name="searchForm"]').serializeArray()
		var datas = {'is_con':1,'t':Math.random()}
		for(var i=0;i<data.length;i++){
			datas[data[i].name] = data[i].value
		}
		$.ajax({
			url:'',
			data:datas,
			type:'get',
			dataType:'html',
			success:function(e){
				t.style.cursor = 'pointer'
				$('#conreturn').html(e)
			}
		})
	}
})
</script>
{% endifequal %}
<style>
td{
	padding:2px;
	border:1px dotted #333;
}
th{
	background:#EAF1FB;
	border:1px dotted #333;
	padding:2px;
}
.selectdate{
	width:auto;float:left;padding:3px;background:#fff;border:1px dotted #333;margin:2px;cursor:pointer;
}
.selectdate:hover{
	background:#EAF1FB;
}
</style>
<div id="conreturn" style="margin:10px;">
	{%if error_info%}
		<span class='red'>{{error_info}}</span>
	{%else%}
	<table width="90%">
		<tr>
			<td colspan="200"  style="border:1px solid #333;">
				<table width='100%'>
				  <tr>
					<td colspan='2' align='left' style="line-height:25px;background:#FFFFCD;border:0px;padding:3px;"><strong id='report_title'>Sales Report <span id='date_title'></span><span id='pro_title'></span></strong></td>
					<td colspan='4' align='right' style="line-height:25px;background:#FFFFCD;border:0px;padding:3px;"><strong>Date:</strong>&nbsp;
					<span id="report_start">{{begin|date:"M d,Y"}}</span> - {{end|date:"M d,Y"}}</td>
				  </tr>
				</table>
			</td>
		</tr>
		<tr>
			<th width="100px">Program</th>
			<th width="200px">New Application Name</th>
			<th width="150px">Sales Person</th>
			<th width="150px">Payment for</th>
			<th width="100px">Amount</th>
			<th width="250px">Remarks</th>
		</tr>
{%if sales_ret%}
	{%for sale in sales_ret%}
		<tr align='center'>
			<td>{{sale.name}}</td>
			<td colspan="10">
				<table width="100%" class="aui-ibox-data aui-dotted-split">
					{%for sinfo in sale.value%}
						<tr>
							<td width="200px" style="border:0px">{{sinfo.0}}</td>
							<td width="150px" style="border:0px">{{sinfo.1}}</td>
							<td width="150px" style="border:0px">{{sinfo.2|date:"M d,Y"}}</td>
							<td width="100px" style="border:0px">{{sinfo.3}}</td>
							<td width="250px" style="border:0px">{{sinfo.4}}</td>
						</tr>
					{%endfor%}
					<tr style="border-top:1px solid #333;">
						<td style="border:0px"></td>
						<td style="border:0px"></td>
						<td style="border:0px" align='right'>Subtotal:</td>
						<td colspan='2' style="border:0px;">{{sale.tolmoneys}}</td>
					</tr>
				</table>
			</td>
		</tr>
	{%endfor%}
		<tr>
			<td style="border:0px"></td>
			<td style="border:0px"></td>
			<td align='right'>Grand Total:</td>
			<td colspan='3'>{%if tolmoney%}{{tolmoney}}{%else%}0{%endif%}</td>
		</tr>
{%else%}
		<tr>
			<td colspan="10" align="center">
				<p style="color:green;line-height:30px;">No Result!</p>
			</td>
		</tr>
{%endif%}
	</table>
	{%endif%}
</div>
<script>
	var date_title = $('.active_title').text()
	var pro_title = $('#p_id option:selected').text()
	if(date_title){
		$('#date_title').html('('+date_title+')')
	}
	if($('#p_id option:selected').val()!=0){
		$('#pro_title').html(' -'+pro_title)
	}
</script>
{% endblock %}

